--DO NOT MODIFY THIS FILE. IT IS ALWAYS OVERWRITTEN ON GENERATION.

--##SECTION BEGIN [INTERNAL STORED PROCS]

--This SQL is generated for internal stored procedures for table [Administrator]
if exists(select * from sys.objects where name = 'gen_Administrator_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Administrator_Delete]
GO

if exists(select * from sys.objects where name = 'gen_Administrator_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Administrator_Insert]
GO

if exists(select * from sys.objects where name = 'gen_Administrator_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Administrator_Update]
GO

--This SQL is generated for internal stored procedures for table [BodyType]
if exists(select * from sys.objects where name = 'gen_BodyType_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_BodyType_Delete]
GO

if exists(select * from sys.objects where name = 'gen_BodyType_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_BodyType_Insert]
GO

if exists(select * from sys.objects where name = 'gen_BodyType_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_BodyType_Update]
GO

--This SQL is generated for internal stored procedures for table [BulletPoint]
if exists(select * from sys.objects where name = 'gen_BulletPoint_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_BulletPoint_Delete]
GO

if exists(select * from sys.objects where name = 'gen_BulletPoint_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_BulletPoint_Insert]
GO

if exists(select * from sys.objects where name = 'gen_BulletPoint_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_BulletPoint_Update]
GO

--This SQL is generated for internal stored procedures for table [City]
if exists(select * from sys.objects where name = 'gen_City_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_City_Delete]
GO

if exists(select * from sys.objects where name = 'gen_City_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_City_Insert]
GO

if exists(select * from sys.objects where name = 'gen_City_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_City_Update]
GO

--This SQL is generated for internal stored procedures for table [CityZip]
if exists(select * from sys.objects where name = 'gen_CityZip_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_CityZip_Delete]
GO

if exists(select * from sys.objects where name = 'gen_CityZip_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_CityZip_Insert]
GO

--This SQL is generated for internal stored procedures for table [Color]
if exists(select * from sys.objects where name = 'gen_Color_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Color_Delete]
GO

if exists(select * from sys.objects where name = 'gen_Color_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Color_Insert]
GO

if exists(select * from sys.objects where name = 'gen_Color_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Color_Update]
GO

--This SQL is generated for internal stored procedures for table [Condition]
if exists(select * from sys.objects where name = 'gen_Condition_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Condition_Delete]
GO

if exists(select * from sys.objects where name = 'gen_Condition_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Condition_Insert]
GO

if exists(select * from sys.objects where name = 'gen_Condition_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Condition_Update]
GO

--This SQL is generated for internal stored procedures for table [ConfigSetting]
if exists(select * from sys.objects where name = 'gen_ConfigSetting_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_ConfigSetting_Delete]
GO

if exists(select * from sys.objects where name = 'gen_ConfigSetting_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_ConfigSetting_Insert]
GO

if exists(select * from sys.objects where name = 'gen_ConfigSetting_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_ConfigSetting_Update]
GO

--This SQL is generated for internal stored procedures for table [Dealer]
if exists(select * from sys.objects where name = 'gen_Dealer_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Dealer_Delete]
GO

if exists(select * from sys.objects where name = 'gen_Dealer_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Dealer_Insert]
GO

if exists(select * from sys.objects where name = 'gen_Dealer_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Dealer_Update]
GO

--This SQL is generated for internal stored procedures for table [Feature]
if exists(select * from sys.objects where name = 'gen_Feature_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Feature_Delete]
GO

if exists(select * from sys.objects where name = 'gen_Feature_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Feature_Insert]
GO

if exists(select * from sys.objects where name = 'gen_Feature_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Feature_Update]
GO

--This SQL is generated for internal stored procedures for table [FuelType]
if exists(select * from sys.objects where name = 'gen_FuelType_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_FuelType_Delete]
GO

if exists(select * from sys.objects where name = 'gen_FuelType_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_FuelType_Insert]
GO

if exists(select * from sys.objects where name = 'gen_FuelType_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_FuelType_Update]
GO

--This SQL is generated for internal stored procedures for table [Listing]
if exists(select * from sys.objects where name = 'gen_Listing_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Listing_Delete]
GO

if exists(select * from sys.objects where name = 'gen_Listing_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Listing_Insert]
GO

if exists(select * from sys.objects where name = 'gen_Listing_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Listing_Update]
GO

--This SQL is generated for internal stored procedures for table [ListingFeature]
if exists(select * from sys.objects where name = 'gen_ListingFeature_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_ListingFeature_Delete]
GO

if exists(select * from sys.objects where name = 'gen_ListingFeature_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_ListingFeature_Insert]
GO

--This SQL is generated for internal stored procedures for table [ListingImage]
if exists(select * from sys.objects where name = 'gen_ListingImage_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_ListingImage_Delete]
GO

if exists(select * from sys.objects where name = 'gen_ListingImage_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_ListingImage_Insert]
GO

if exists(select * from sys.objects where name = 'gen_ListingImage_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_ListingImage_Update]
GO

--This SQL is generated for internal stored procedures for table [ListingPremium]
if exists(select * from sys.objects where name = 'gen_ListingPremium_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_ListingPremium_Delete]
GO

if exists(select * from sys.objects where name = 'gen_ListingPremium_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_ListingPremium_Insert]
GO

if exists(select * from sys.objects where name = 'gen_ListingPremium_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_ListingPremium_Update]
GO

--This SQL is generated for internal stored procedures for table [ListingSaved]
if exists(select * from sys.objects where name = 'gen_ListingSaved_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_ListingSaved_Delete]
GO

if exists(select * from sys.objects where name = 'gen_ListingSaved_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_ListingSaved_Insert]
GO

if exists(select * from sys.objects where name = 'gen_ListingSaved_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_ListingSaved_Update]
GO

--This SQL is generated for internal stored procedures for table [ListingView]
if exists(select * from sys.objects where name = 'gen_ListingView_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_ListingView_Delete]
GO

if exists(select * from sys.objects where name = 'gen_ListingView_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_ListingView_Insert]
GO

if exists(select * from sys.objects where name = 'gen_ListingView_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_ListingView_Update]
GO

--This SQL is generated for internal stored procedures for table [Make]
if exists(select * from sys.objects where name = 'gen_Make_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Make_Delete]
GO

if exists(select * from sys.objects where name = 'gen_Make_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Make_Insert]
GO

if exists(select * from sys.objects where name = 'gen_Make_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Make_Update]
GO

--This SQL is generated for internal stored procedures for table [MakeModel]
if exists(select * from sys.objects where name = 'gen_MakeModel_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_MakeModel_Delete]
GO

if exists(select * from sys.objects where name = 'gen_MakeModel_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_MakeModel_Insert]
GO

if exists(select * from sys.objects where name = 'gen_MakeModel_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_MakeModel_Update]
GO

--This SQL is generated for internal stored procedures for table [Metro]
if exists(select * from sys.objects where name = 'gen_Metro_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Metro_Delete]
GO

if exists(select * from sys.objects where name = 'gen_Metro_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Metro_Insert]
GO

if exists(select * from sys.objects where name = 'gen_Metro_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Metro_Update]
GO

--This SQL is generated for internal stored procedures for table [MetroState]
if exists(select * from sys.objects where name = 'gen_MetroState_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_MetroState_Delete]
GO

if exists(select * from sys.objects where name = 'gen_MetroState_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_MetroState_Insert]
GO

--This SQL is generated for internal stored procedures for table [MetroZip]
if exists(select * from sys.objects where name = 'gen_MetroZip_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_MetroZip_Delete]
GO

if exists(select * from sys.objects where name = 'gen_MetroZip_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_MetroZip_Insert]
GO

--This SQL is generated for internal stored procedures for table [Model]
if exists(select * from sys.objects where name = 'gen_Model_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Model_Delete]
GO

if exists(select * from sys.objects where name = 'gen_Model_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Model_Insert]
GO

if exists(select * from sys.objects where name = 'gen_Model_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Model_Update]
GO

--This SQL is generated for internal stored procedures for table [SearchSaved]
if exists(select * from sys.objects where name = 'gen_SearchSaved_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_SearchSaved_Delete]
GO

if exists(select * from sys.objects where name = 'gen_SearchSaved_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_SearchSaved_Insert]
GO

if exists(select * from sys.objects where name = 'gen_SearchSaved_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_SearchSaved_Update]
GO

--This SQL is generated for internal stored procedures for table [SearchSavedCriteria]
if exists(select * from sys.objects where name = 'gen_SearchSavedCriteria_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_SearchSavedCriteria_Delete]
GO

if exists(select * from sys.objects where name = 'gen_SearchSavedCriteria_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_SearchSavedCriteria_Insert]
GO

if exists(select * from sys.objects where name = 'gen_SearchSavedCriteria_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_SearchSavedCriteria_Update]
GO

--This SQL is generated for internal stored procedures for table [State]
if exists(select * from sys.objects where name = 'gen_State_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_State_Delete]
GO

if exists(select * from sys.objects where name = 'gen_State_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_State_Insert]
GO

if exists(select * from sys.objects where name = 'gen_State_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_State_Update]
GO

--This SQL is generated for internal stored procedures for table [Transmission]
if exists(select * from sys.objects where name = 'gen_Transmission_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Transmission_Delete]
GO

if exists(select * from sys.objects where name = 'gen_Transmission_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Transmission_Insert]
GO

if exists(select * from sys.objects where name = 'gen_Transmission_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Transmission_Update]
GO

--This SQL is generated for internal stored procedures for table [UserAccount]
if exists(select * from sys.objects where name = 'gen_UserAccount_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_UserAccount_Delete]
GO

if exists(select * from sys.objects where name = 'gen_UserAccount_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_UserAccount_Insert]
GO

if exists(select * from sys.objects where name = 'gen_UserAccount_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_UserAccount_Update]
GO

--This SQL is generated for internal stored procedures for table [UserLoginHistory]
if exists(select * from sys.objects where name = 'gen_UserLoginHistory_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_UserLoginHistory_Delete]
GO

if exists(select * from sys.objects where name = 'gen_UserLoginHistory_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_UserLoginHistory_Insert]
GO

if exists(select * from sys.objects where name = 'gen_UserLoginHistory_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_UserLoginHistory_Update]
GO

--This SQL is generated for internal stored procedures for table [UserType]
if exists(select * from sys.objects where name = 'gen_UserType_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_UserType_Delete]
GO

if exists(select * from sys.objects where name = 'gen_UserType_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_UserType_Insert]
GO

if exists(select * from sys.objects where name = 'gen_UserType_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_UserType_Update]
GO

--This SQL is generated for internal stored procedures for table [VistorContact]
if exists(select * from sys.objects where name = 'gen_VistorContact_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_VistorContact_Delete]
GO

if exists(select * from sys.objects where name = 'gen_VistorContact_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_VistorContact_Insert]
GO

if exists(select * from sys.objects where name = 'gen_VistorContact_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_VistorContact_Update]
GO

--This SQL is generated for internal stored procedures for table [Zip]
if exists(select * from sys.objects where name = 'gen_Zip_Delete' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Zip_Delete]
GO

if exists(select * from sys.objects where name = 'gen_Zip_Insert' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Zip_Insert]
GO

if exists(select * from sys.objects where name = 'gen_Zip_Update' and type = 'P' and type_desc = 'SQL_STORED_PROCEDURE')
	drop procedure [dbo].[gen_Zip_Update]
GO

--##SECTION END [INTERNAL STORED PROCS]

